home *** CD-ROM | disk | FTP | other *** search
- OOFILE Validation Suite - Test 28
- Use keyword indexing to retrieve by words within fields.
- Adding test data
-
- People with 'bloke' in their Description (keyword file non-indexed):
- Last Name Other Names
-
- Smith John
-
- People with word starting with 'blo' in their Description (John Smith):
- Last Name Other Names
-
- Smith John
-
- Now rebuilding the database indices, to see if above faster
- People with 'bloke' in their Description (John Smith):
- Last Name Other Names
-
- Smith John
-
- People with 'blo' in their Description (nobody):
- Last Name Other Names
-
-
- People with word starting with 'blo' in their Description (John Smith):
- Last Name Other Names
-
- Smith John
-
- People with 'Andy' in their Description (Andy & Trissa Dent):
- Last Name Other Names
-
- Dent Trissa
- Dent Andy
-
- People with 'Andy' in their Description and also (via searchSelection) 'married' (Trissa Dent):
- Last Name Other Names
-
- Dent Trissa
-
- People with 'bloke' in their Description (John Smith & Trissa Dent):
- Last Name Other Names
-
- Smith John
- Dent Trissa
-
- People with 'bloke' or 'software' in their Description (John Smith, Andy & Trissa Dent):
- Last Name Other Names
-
- Smith John
- Dent Trissa
- Dent Andy
-
- People with 'bloke' and 'software' in their Description (nobody):
- Last Name Other Names
-
-
- People with 'blo' and 'so' in their Description (John Smith):
- Last Name Other Names
-
- Smith John
-
- People with 'giraffe' or 'boots' in their Description (John Smith):
- Last Name Other Names
-
- Smith John
-
- People with 'giraffe' and 'boots' in their Description (nobody):
- Last Name Other Names
-
-
-
-
- ******** Now search table, regardless of field *********
-
- People with 'bloke' (John Smith & Trissa Dent):
- Last Name Other Names
-
- Smith John
- Dent Trissa
-
- People with 'bloke' or 'software' (John Smith, Andy & Trissa Dent):
- Last Name Other Names
-
- Smith John
- Dent Trissa
- Dent Andy
-
- People with 'bloke' and 'software' (nobody):
- Last Name Other Names
-
-
- People with 'blo' and 'so' (John Smith):
- Last Name Other Names
-
- Smith John
-
- People with 'giraffe' or 'boots' (John Smith):
- Last Name Other Names
-
- Smith John
-
- People with 'giraffe' and 'boots' (nobody):
- Last Name Other Names
-
-
- People with 'Trissa' and 'married' (Trissa Dent):
- Last Name Other Names
-
- Dent Trissa
-
- Test Completed
-